SQLSchema Options Dialog

Default Settings

Always show Rename dialog

If SQLSchema detects unmatched objects of the same type (e.g. tables) in both the source and the destination database, it will display the Rename Object Dialog to allow the operator to associate renamed objects.
If this option is checked, the dialog is always displayed.

Ignore possible data loss with field changes

Some field changes may cause data loss (e.g. when truncating a Varchar column). Checking this option does not generate a warning before executing the change script.

Create Schema Cache

Creates a local cache file with the schema information of the databases.

Use Schema Cache

Uses the local cache file to retrieve the schema information if SQLSchema detects that no changes occurred in the database and the cache file is up-to-date.

Filter Set Server

SQLSchema lets you filter the set of objects to be compared, and allows the specification of some options for the comparison.

Filter Set Server

The SQL Server which stores the filter sets.

Filter Set Database

The SQL Server database which stores the filter sets.

Connect/Reload

Connect to the specified server and load the current filter sets.

Filter Sets

Filter Sets

Filter sets are organized hierarchically, and contain Filter Set Elements.
During schema comparison, both the filter sets and their elements can be selected individually to specify included and excluded objects.

Right click for the following commands:

- Add New Set

Adds a new filter set on the same level as the current filter set.

- Add New Child Set

Adds a new filter set below the current filter set.

- Delete Set

Deletes the current filter set.

Filter Elements

Each filter set contains filter elements. Each filter element can be configured in the Filter Element Property Dialog.

Right click for the following commands:

- Add Element

Adds a filter element.

- Edit Element

Edits the current filter element.

- Delete Element

Delete the current filter element.